﻿/*CREATE TABLE [dbo].[Resouce] (
    [Id]                    INT            IDENTITY (1, 1) NOT NULL,
    [GeId]                  INT            NOT NULL,
    [SoeId]                 NVARCHAR (7)   NOT NULL,
    [FullName]              NVARCHAR (120) NOT NULL,
    [GOCId]                 NVARCHAR (10)  NULL,
    [LocalCode]             NVARCHAR (10)  NULL,
    [BusinessId]            INT            NULL,
    [OperateId]             INT            NULL,
    [ManagedSegmentId]      INT            NULL,
    [HumanResourceDeptId]   INT            NULL,
    [JobTitleId]            INT            NULL,
    [GlobalFunction]        NVARCHAR (10)  NULL,
    [Status]                NVARCHAR (10)  NULL,
    [EmployeeClassId]       INT            NULL,
    [FullOrPartTime]        CHAR (1)       NULL,
    [RegOrTemp]             CHAR (1)       NULL,
    [DirectFlag]            CHAR (1)       NULL,
    [DirectCount]           INT            NULL,
    [FTEId]                 INT            NULL,
    [TotalHour]             DECIMAL (5, 2) NULL,
    [StandardHour]          DECIMAL (5, 2) NULL,
    [WorkingMonth]         DATETIME       NULL,
    [FullMonth]             DATETIME       NULL,
    [BusinessContactId]     INT            NULL,
    [VendorId]              INT            NULL,
    [Currency]              NCHAR (10)     NULL,
    [BillRate]              DECIMAL (5, 2) NULL,
    [LocationId]            INT            NULL,
    [DomicileCountryId]     INT            NULL,
    [ExpenseCodeId]         INT            NULL,
    [OUCId]                 INT            NULL,
    [OfficerId]             INT            NULL,
    [HrResponsibleGeId]     INT            NULL,
    [DirectManagerGeId]     INT            NULL,
    [HumanResourceDeptL2Id] INT            NULL,
    [HumanResourceDeptL3Id] INT            NULL,
    [HumanResourceDeptL4Id] INT            NULL,
    [HumanResourceDeptL5Id] INT            NULL,
    [HumanResourceDeptL6Id] INT            NULL,
    [HumanResourceDeptL7Id] INT            NULL,
    [HumanResourceDeptL8Id] INT            NULL,
    [HumanResourceDeptL9Id] INT            NULL,
    [ManagedGeographyL2Id]  INT            NULL,
    [ManagedGeographyL3Id]  INT            NULL,
    [ManagedGeographyL4Id]  INT            NULL,
    [ManagedGeographyL5Id]  INT            NULL,
    [ManagedGeographyL6Id]  INT            NULL,
    [ManagedGeographyL7Id]  INT            NULL,
    [ManagedGeographyL8Id]  INT            NULL,
    [ManagedGeographyL9Id]  INT            NULL,
    [LastUpdate]            DATETIME       NULL,
    [ReferenceDate]         DATETIME       NULL
);*/

